Tableau 10.0 Best Practices by Unknown

Author:Unknown
Language: eng
Format: mobi, epub
Publisher: Packt Publishing

Data blending limitation with COUNTD

Data blending has some limitations regarding non-additive aggregates, such as COUNTD, MEDIAN, and RAWSQLAGG. These limitations cause certain fields in the view to become invalid in certain circumstances. If you hover your mouse cursor over one of these fields, the error is: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation."

The limitations are as follows:

If a non-additive aggregation from the primary data source is in the view, you cannot use a group created in the primary data source in the view. As a workaround, you can change the group into a calculated field.

Non-additive aggregates are only supported for the primary data source if that data source is a relational data source that allows the use of temporary tables. Non-additive aggregates are not supported for any secondary data sources. If you need a non-additive aggregate on the primary data source, but your data source does not support temporary tables, you can create an extract. Tableau data extracts support temporary tables. If you are using a secondary dimension, try changing the dimension to an attribute. However, using Attribute might replace values with an asterisk (*), which means that there are multiple values in your data at this level of detail, and Tableau can't determine which to display.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.